
USE [DSRSystem_Temp]
GO
-- use only when needed

ALTER DATABASE DSRSystem_temp
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE DSRSystem_temp
SET READ_COMMITTED_SNAPSHOT ON
WITH ROLLBACK IMMEDIATE;
GO


USE [DSRSystem]
GO
-- use only when needed

ALTER DATABASE DSRSystem
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE DSRSystem
SET READ_COMMITTED_SNAPSHOT ON
WITH ROLLBACK IMMEDIATE;
GO